You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column. (Error 3622)

The server-generated IDENTITY values cannot be reflected at the client side unless you use the DAO property dbSeeChanges.